package com.dscs.model;

import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.List;

public class BuildingExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public BuildingExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        protected void addCriterionForJDBCDate(String condition, Date value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value.getTime()), property);
        }

        protected void addCriterionForJDBCDate(String condition, List<Date> values, String property) {
            if (values == null || values.size() == 0) {
                throw new RuntimeException("Value list for " + property + " cannot be null or empty");
            }
            List<java.sql.Date> dateList = new ArrayList<java.sql.Date>();
            Iterator<Date> iter = values.iterator();
            while (iter.hasNext()) {
                dateList.add(new java.sql.Date(iter.next().getTime()));
            }
            addCriterion(condition, dateList, property);
        }

        protected void addCriterionForJDBCDate(String condition, Date value1, Date value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value1.getTime()), new java.sql.Date(value2.getTime()), property);
        }

        public Criteria andBuildIdIsNull() {
            addCriterion("build_id is null");
            return (Criteria) this;
        }

        public Criteria andBuildIdIsNotNull() {
            addCriterion("build_id is not null");
            return (Criteria) this;
        }

        public Criteria andBuildIdEqualTo(Long value) {
            addCriterion("build_id =", value, "buildId");
            return (Criteria) this;
        }

        public Criteria andBuildIdNotEqualTo(Long value) {
            addCriterion("build_id <>", value, "buildId");
            return (Criteria) this;
        }

        public Criteria andBuildIdGreaterThan(Long value) {
            addCriterion("build_id >", value, "buildId");
            return (Criteria) this;
        }

        public Criteria andBuildIdGreaterThanOrEqualTo(Long value) {
            addCriterion("build_id >=", value, "buildId");
            return (Criteria) this;
        }

        public Criteria andBuildIdLessThan(Long value) {
            addCriterion("build_id <", value, "buildId");
            return (Criteria) this;
        }

        public Criteria andBuildIdLessThanOrEqualTo(Long value) {
            addCriterion("build_id <=", value, "buildId");
            return (Criteria) this;
        }

        public Criteria andBuildIdIn(List<Long> values) {
            addCriterion("build_id in", values, "buildId");
            return (Criteria) this;
        }

        public Criteria andBuildIdNotIn(List<Long> values) {
            addCriterion("build_id not in", values, "buildId");
            return (Criteria) this;
        }

        public Criteria andBuildIdBetween(Long value1, Long value2) {
            addCriterion("build_id between", value1, value2, "buildId");
            return (Criteria) this;
        }

        public Criteria andBuildIdNotBetween(Long value1, Long value2) {
            addCriterion("build_id not between", value1, value2, "buildId");
            return (Criteria) this;
        }

        public Criteria andBuildNameIsNull() {
            addCriterion("build_name is null");
            return (Criteria) this;
        }

        public Criteria andBuildNameIsNotNull() {
            addCriterion("build_name is not null");
            return (Criteria) this;
        }

        public Criteria andBuildNameEqualTo(String value) {
            addCriterion("build_name =", value, "buildName");
            return (Criteria) this;
        }

        public Criteria andBuildNameNotEqualTo(String value) {
            addCriterion("build_name <>", value, "buildName");
            return (Criteria) this;
        }

        public Criteria andBuildNameGreaterThan(String value) {
            addCriterion("build_name >", value, "buildName");
            return (Criteria) this;
        }

        public Criteria andBuildNameGreaterThanOrEqualTo(String value) {
            addCriterion("build_name >=", value, "buildName");
            return (Criteria) this;
        }

        public Criteria andBuildNameLessThan(String value) {
            addCriterion("build_name <", value, "buildName");
            return (Criteria) this;
        }

        public Criteria andBuildNameLessThanOrEqualTo(String value) {
            addCriterion("build_name <=", value, "buildName");
            return (Criteria) this;
        }

        public Criteria andBuildNameLike(String value) {
            addCriterion("build_name like", value, "buildName");
            return (Criteria) this;
        }

        public Criteria andBuildNameNotLike(String value) {
            addCriterion("build_name not like", value, "buildName");
            return (Criteria) this;
        }

        public Criteria andBuildNameIn(List<String> values) {
            addCriterion("build_name in", values, "buildName");
            return (Criteria) this;
        }

        public Criteria andBuildNameNotIn(List<String> values) {
            addCriterion("build_name not in", values, "buildName");
            return (Criteria) this;
        }

        public Criteria andBuildNameBetween(String value1, String value2) {
            addCriterion("build_name between", value1, value2, "buildName");
            return (Criteria) this;
        }

        public Criteria andBuildNameNotBetween(String value1, String value2) {
            addCriterion("build_name not between", value1, value2, "buildName");
            return (Criteria) this;
        }

        public Criteria andBuildCodeIsNull() {
            addCriterion("build_code is null");
            return (Criteria) this;
        }

        public Criteria andBuildCodeIsNotNull() {
            addCriterion("build_code is not null");
            return (Criteria) this;
        }

        public Criteria andBuildCodeEqualTo(String value) {
            addCriterion("build_code =", value, "buildCode");
            return (Criteria) this;
        }

        public Criteria andBuildCodeNotEqualTo(String value) {
            addCriterion("build_code <>", value, "buildCode");
            return (Criteria) this;
        }

        public Criteria andBuildCodeGreaterThan(String value) {
            addCriterion("build_code >", value, "buildCode");
            return (Criteria) this;
        }

        public Criteria andBuildCodeGreaterThanOrEqualTo(String value) {
            addCriterion("build_code >=", value, "buildCode");
            return (Criteria) this;
        }

        public Criteria andBuildCodeLessThan(String value) {
            addCriterion("build_code <", value, "buildCode");
            return (Criteria) this;
        }

        public Criteria andBuildCodeLessThanOrEqualTo(String value) {
            addCriterion("build_code <=", value, "buildCode");
            return (Criteria) this;
        }

        public Criteria andBuildCodeLike(String value) {
            addCriterion("build_code like", value, "buildCode");
            return (Criteria) this;
        }

        public Criteria andBuildCodeNotLike(String value) {
            addCriterion("build_code not like", value, "buildCode");
            return (Criteria) this;
        }

        public Criteria andBuildCodeIn(List<String> values) {
            addCriterion("build_code in", values, "buildCode");
            return (Criteria) this;
        }

        public Criteria andBuildCodeNotIn(List<String> values) {
            addCriterion("build_code not in", values, "buildCode");
            return (Criteria) this;
        }

        public Criteria andBuildCodeBetween(String value1, String value2) {
            addCriterion("build_code between", value1, value2, "buildCode");
            return (Criteria) this;
        }

        public Criteria andBuildCodeNotBetween(String value1, String value2) {
            addCriterion("build_code not between", value1, value2, "buildCode");
            return (Criteria) this;
        }

        public Criteria andBuildNoIsNull() {
            addCriterion("build_no is null");
            return (Criteria) this;
        }

        public Criteria andBuildNoIsNotNull() {
            addCriterion("build_no is not null");
            return (Criteria) this;
        }

        public Criteria andBuildNoEqualTo(String value) {
            addCriterion("build_no =", value, "buildNo");
            return (Criteria) this;
        }

        public Criteria andBuildNoNotEqualTo(String value) {
            addCriterion("build_no <>", value, "buildNo");
            return (Criteria) this;
        }

        public Criteria andBuildNoGreaterThan(String value) {
            addCriterion("build_no >", value, "buildNo");
            return (Criteria) this;
        }

        public Criteria andBuildNoGreaterThanOrEqualTo(String value) {
            addCriterion("build_no >=", value, "buildNo");
            return (Criteria) this;
        }

        public Criteria andBuildNoLessThan(String value) {
            addCriterion("build_no <", value, "buildNo");
            return (Criteria) this;
        }

        public Criteria andBuildNoLessThanOrEqualTo(String value) {
            addCriterion("build_no <=", value, "buildNo");
            return (Criteria) this;
        }

        public Criteria andBuildNoLike(String value) {
            addCriterion("build_no like", value, "buildNo");
            return (Criteria) this;
        }

        public Criteria andBuildNoNotLike(String value) {
            addCriterion("build_no not like", value, "buildNo");
            return (Criteria) this;
        }

        public Criteria andBuildNoIn(List<String> values) {
            addCriterion("build_no in", values, "buildNo");
            return (Criteria) this;
        }

        public Criteria andBuildNoNotIn(List<String> values) {
            addCriterion("build_no not in", values, "buildNo");
            return (Criteria) this;
        }

        public Criteria andBuildNoBetween(String value1, String value2) {
            addCriterion("build_no between", value1, value2, "buildNo");
            return (Criteria) this;
        }

        public Criteria andBuildNoNotBetween(String value1, String value2) {
            addCriterion("build_no not between", value1, value2, "buildNo");
            return (Criteria) this;
        }

        public Criteria andBuildNumIsNull() {
            addCriterion("build_num is null");
            return (Criteria) this;
        }

        public Criteria andBuildNumIsNotNull() {
            addCriterion("build_num is not null");
            return (Criteria) this;
        }

        public Criteria andBuildNumEqualTo(Integer value) {
            addCriterion("build_num =", value, "buildNum");
            return (Criteria) this;
        }

        public Criteria andBuildNumNotEqualTo(Integer value) {
            addCriterion("build_num <>", value, "buildNum");
            return (Criteria) this;
        }

        public Criteria andBuildNumGreaterThan(Integer value) {
            addCriterion("build_num >", value, "buildNum");
            return (Criteria) this;
        }

        public Criteria andBuildNumGreaterThanOrEqualTo(Integer value) {
            addCriterion("build_num >=", value, "buildNum");
            return (Criteria) this;
        }

        public Criteria andBuildNumLessThan(Integer value) {
            addCriterion("build_num <", value, "buildNum");
            return (Criteria) this;
        }

        public Criteria andBuildNumLessThanOrEqualTo(Integer value) {
            addCriterion("build_num <=", value, "buildNum");
            return (Criteria) this;
        }

        public Criteria andBuildNumIn(List<Integer> values) {
            addCriterion("build_num in", values, "buildNum");
            return (Criteria) this;
        }

        public Criteria andBuildNumNotIn(List<Integer> values) {
            addCriterion("build_num not in", values, "buildNum");
            return (Criteria) this;
        }

        public Criteria andBuildNumBetween(Integer value1, Integer value2) {
            addCriterion("build_num between", value1, value2, "buildNum");
            return (Criteria) this;
        }

        public Criteria andBuildNumNotBetween(Integer value1, Integer value2) {
            addCriterion("build_num not between", value1, value2, "buildNum");
            return (Criteria) this;
        }

        public Criteria andNuildUnitIsNull() {
            addCriterion("nuild_unit is null");
            return (Criteria) this;
        }

        public Criteria andNuildUnitIsNotNull() {
            addCriterion("nuild_unit is not null");
            return (Criteria) this;
        }

        public Criteria andNuildUnitEqualTo(Integer value) {
            addCriterion("nuild_unit =", value, "nuildUnit");
            return (Criteria) this;
        }

        public Criteria andNuildUnitNotEqualTo(Integer value) {
            addCriterion("nuild_unit <>", value, "nuildUnit");
            return (Criteria) this;
        }

        public Criteria andNuildUnitGreaterThan(Integer value) {
            addCriterion("nuild_unit >", value, "nuildUnit");
            return (Criteria) this;
        }

        public Criteria andNuildUnitGreaterThanOrEqualTo(Integer value) {
            addCriterion("nuild_unit >=", value, "nuildUnit");
            return (Criteria) this;
        }

        public Criteria andNuildUnitLessThan(Integer value) {
            addCriterion("nuild_unit <", value, "nuildUnit");
            return (Criteria) this;
        }

        public Criteria andNuildUnitLessThanOrEqualTo(Integer value) {
            addCriterion("nuild_unit <=", value, "nuildUnit");
            return (Criteria) this;
        }

        public Criteria andNuildUnitIn(List<Integer> values) {
            addCriterion("nuild_unit in", values, "nuildUnit");
            return (Criteria) this;
        }

        public Criteria andNuildUnitNotIn(List<Integer> values) {
            addCriterion("nuild_unit not in", values, "nuildUnit");
            return (Criteria) this;
        }

        public Criteria andNuildUnitBetween(Integer value1, Integer value2) {
            addCriterion("nuild_unit between", value1, value2, "nuildUnit");
            return (Criteria) this;
        }

        public Criteria andNuildUnitNotBetween(Integer value1, Integer value2) {
            addCriterion("nuild_unit not between", value1, value2, "nuildUnit");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdIsNull() {
            addCriterion("create_user_id is null");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdIsNotNull() {
            addCriterion("create_user_id is not null");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdEqualTo(Long value) {
            addCriterion("create_user_id =", value, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdNotEqualTo(Long value) {
            addCriterion("create_user_id <>", value, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdGreaterThan(Long value) {
            addCriterion("create_user_id >", value, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdGreaterThanOrEqualTo(Long value) {
            addCriterion("create_user_id >=", value, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdLessThan(Long value) {
            addCriterion("create_user_id <", value, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdLessThanOrEqualTo(Long value) {
            addCriterion("create_user_id <=", value, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdIn(List<Long> values) {
            addCriterion("create_user_id in", values, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdNotIn(List<Long> values) {
            addCriterion("create_user_id not in", values, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdBetween(Long value1, Long value2) {
            addCriterion("create_user_id between", value1, value2, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdNotBetween(Long value1, Long value2) {
            addCriterion("create_user_id not between", value1, value2, "createUserId");
            return (Criteria) this;
        }

        public Criteria andDutyUserIdIsNull() {
            addCriterion("duty_user_id is null");
            return (Criteria) this;
        }

        public Criteria andDutyUserIdIsNotNull() {
            addCriterion("duty_user_id is not null");
            return (Criteria) this;
        }

        public Criteria andDutyUserIdEqualTo(Integer value) {
            addCriterion("duty_user_id =", value, "dutyUserId");
            return (Criteria) this;
        }

        public Criteria andDutyUserIdNotEqualTo(Integer value) {
            addCriterion("duty_user_id <>", value, "dutyUserId");
            return (Criteria) this;
        }

        public Criteria andDutyUserIdGreaterThan(Integer value) {
            addCriterion("duty_user_id >", value, "dutyUserId");
            return (Criteria) this;
        }

        public Criteria andDutyUserIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("duty_user_id >=", value, "dutyUserId");
            return (Criteria) this;
        }

        public Criteria andDutyUserIdLessThan(Integer value) {
            addCriterion("duty_user_id <", value, "dutyUserId");
            return (Criteria) this;
        }

        public Criteria andDutyUserIdLessThanOrEqualTo(Integer value) {
            addCriterion("duty_user_id <=", value, "dutyUserId");
            return (Criteria) this;
        }

        public Criteria andDutyUserIdIn(List<Integer> values) {
            addCriterion("duty_user_id in", values, "dutyUserId");
            return (Criteria) this;
        }

        public Criteria andDutyUserIdNotIn(List<Integer> values) {
            addCriterion("duty_user_id not in", values, "dutyUserId");
            return (Criteria) this;
        }

        public Criteria andDutyUserIdBetween(Integer value1, Integer value2) {
            addCriterion("duty_user_id between", value1, value2, "dutyUserId");
            return (Criteria) this;
        }

        public Criteria andDutyUserIdNotBetween(Integer value1, Integer value2) {
            addCriterion("duty_user_id not between", value1, value2, "dutyUserId");
            return (Criteria) this;
        }

        public Criteria andWorkDateIsNull() {
            addCriterion("work_date is null");
            return (Criteria) this;
        }

        public Criteria andWorkDateIsNotNull() {
            addCriterion("work_date is not null");
            return (Criteria) this;
        }

        public Criteria andWorkDateEqualTo(Long value) {
            addCriterion("work_date =", value, "workDate");
            return (Criteria) this;
        }

        public Criteria andWorkDateNotEqualTo(Long value) {
            addCriterion("work_date <>", value, "workDate");
            return (Criteria) this;
        }

        public Criteria andWorkDateGreaterThan(Long value) {
            addCriterion("work_date >", value, "workDate");
            return (Criteria) this;
        }

        public Criteria andWorkDateGreaterThanOrEqualTo(Long value) {
            addCriterion("work_date >=", value, "workDate");
            return (Criteria) this;
        }

        public Criteria andWorkDateLessThan(Long value) {
            addCriterion("work_date <", value, "workDate");
            return (Criteria) this;
        }

        public Criteria andWorkDateLessThanOrEqualTo(Long value) {
            addCriterion("work_date <=", value, "workDate");
            return (Criteria) this;
        }

        public Criteria andWorkDateIn(List<Long> values) {
            addCriterion("work_date in", values, "workDate");
            return (Criteria) this;
        }

        public Criteria andWorkDateNotIn(List<Long> values) {
            addCriterion("work_date not in", values, "workDate");
            return (Criteria) this;
        }

        public Criteria andWorkDateBetween(Long value1, Long value2) {
            addCriterion("work_date between", value1, value2, "workDate");
            return (Criteria) this;
        }

        public Criteria andWorkDateNotBetween(Long value1, Long value2) {
            addCriterion("work_date not between", value1, value2, "workDate");
            return (Criteria) this;
        }

        public Criteria andEndWorkIsNull() {
            addCriterion("end_work is null");
            return (Criteria) this;
        }

        public Criteria andEndWorkIsNotNull() {
            addCriterion("end_work is not null");
            return (Criteria) this;
        }

        public Criteria andEndWorkEqualTo(Long value) {
            addCriterion("end_work =", value, "endWork");
            return (Criteria) this;
        }

        public Criteria andEndWorkNotEqualTo(Long value) {
            addCriterion("end_work <>", value, "endWork");
            return (Criteria) this;
        }

        public Criteria andEndWorkGreaterThan(Long value) {
            addCriterion("end_work >", value, "endWork");
            return (Criteria) this;
        }

        public Criteria andEndWorkGreaterThanOrEqualTo(Long value) {
            addCriterion("end_work >=", value, "endWork");
            return (Criteria) this;
        }

        public Criteria andEndWorkLessThan(Long value) {
            addCriterion("end_work <", value, "endWork");
            return (Criteria) this;
        }

        public Criteria andEndWorkLessThanOrEqualTo(Long value) {
            addCriterion("end_work <=", value, "endWork");
            return (Criteria) this;
        }

        public Criteria andEndWorkIn(List<Long> values) {
            addCriterion("end_work in", values, "endWork");
            return (Criteria) this;
        }

        public Criteria andEndWorkNotIn(List<Long> values) {
            addCriterion("end_work not in", values, "endWork");
            return (Criteria) this;
        }

        public Criteria andEndWorkBetween(Long value1, Long value2) {
            addCriterion("end_work between", value1, value2, "endWork");
            return (Criteria) this;
        }

        public Criteria andEndWorkNotBetween(Long value1, Long value2) {
            addCriterion("end_work not between", value1, value2, "endWork");
            return (Criteria) this;
        }

        public Criteria andCreateDateIsNull() {
            addCriterion("create_date is null");
            return (Criteria) this;
        }

        public Criteria andCreateDateIsNotNull() {
            addCriterion("create_date is not null");
            return (Criteria) this;
        }

        public Criteria andCreateDateEqualTo(Date value) {
            addCriterionForJDBCDate("create_date =", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotEqualTo(Date value) {
            addCriterionForJDBCDate("create_date <>", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateGreaterThan(Date value) {
            addCriterionForJDBCDate("create_date >", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("create_date >=", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateLessThan(Date value) {
            addCriterionForJDBCDate("create_date <", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("create_date <=", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateIn(List<Date> values) {
            addCriterionForJDBCDate("create_date in", values, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotIn(List<Date> values) {
            addCriterionForJDBCDate("create_date not in", values, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("create_date between", value1, value2, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("create_date not between", value1, value2, "createDate");
            return (Criteria) this;
        }

        public Criteria andStartDateIsNull() {
            addCriterion("start_date is null");
            return (Criteria) this;
        }

        public Criteria andStartDateIsNotNull() {
            addCriterion("start_date is not null");
            return (Criteria) this;
        }

        public Criteria andStartDateEqualTo(Date value) {
            addCriterionForJDBCDate("start_date =", value, "startDate");
            return (Criteria) this;
        }

        public Criteria andStartDateNotEqualTo(Date value) {
            addCriterionForJDBCDate("start_date <>", value, "startDate");
            return (Criteria) this;
        }

        public Criteria andStartDateGreaterThan(Date value) {
            addCriterionForJDBCDate("start_date >", value, "startDate");
            return (Criteria) this;
        }

        public Criteria andStartDateGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("start_date >=", value, "startDate");
            return (Criteria) this;
        }

        public Criteria andStartDateLessThan(Date value) {
            addCriterionForJDBCDate("start_date <", value, "startDate");
            return (Criteria) this;
        }

        public Criteria andStartDateLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("start_date <=", value, "startDate");
            return (Criteria) this;
        }

        public Criteria andStartDateIn(List<Date> values) {
            addCriterionForJDBCDate("start_date in", values, "startDate");
            return (Criteria) this;
        }

        public Criteria andStartDateNotIn(List<Date> values) {
            addCriterionForJDBCDate("start_date not in", values, "startDate");
            return (Criteria) this;
        }

        public Criteria andStartDateBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("start_date between", value1, value2, "startDate");
            return (Criteria) this;
        }

        public Criteria andStartDateNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("start_date not between", value1, value2, "startDate");
            return (Criteria) this;
        }

        public Criteria andEndDateIsNull() {
            addCriterion("end_date is null");
            return (Criteria) this;
        }

        public Criteria andEndDateIsNotNull() {
            addCriterion("end_date is not null");
            return (Criteria) this;
        }

        public Criteria andEndDateEqualTo(Date value) {
            addCriterionForJDBCDate("end_date =", value, "endDate");
            return (Criteria) this;
        }

        public Criteria andEndDateNotEqualTo(Date value) {
            addCriterionForJDBCDate("end_date <>", value, "endDate");
            return (Criteria) this;
        }

        public Criteria andEndDateGreaterThan(Date value) {
            addCriterionForJDBCDate("end_date >", value, "endDate");
            return (Criteria) this;
        }

        public Criteria andEndDateGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("end_date >=", value, "endDate");
            return (Criteria) this;
        }

        public Criteria andEndDateLessThan(Date value) {
            addCriterionForJDBCDate("end_date <", value, "endDate");
            return (Criteria) this;
        }

        public Criteria andEndDateLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("end_date <=", value, "endDate");
            return (Criteria) this;
        }

        public Criteria andEndDateIn(List<Date> values) {
            addCriterionForJDBCDate("end_date in", values, "endDate");
            return (Criteria) this;
        }

        public Criteria andEndDateNotIn(List<Date> values) {
            addCriterionForJDBCDate("end_date not in", values, "endDate");
            return (Criteria) this;
        }

        public Criteria andEndDateBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("end_date between", value1, value2, "endDate");
            return (Criteria) this;
        }

        public Criteria andEndDateNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("end_date not between", value1, value2, "endDate");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}